-- @author lixiyong01
-- @date 2021.11.11
-- 违法规则表处理结果
--【已下线】 2023.02.14

USE hdp_lbg_supin_zplisting;

CREATE TABLE `hdp_lbg_supin_zplisting.zp_app_comm_governance_table_break_rule`(
  `dbtbl` string COMMENT '库名.表名称',
  `user_name` string COMMENT '表负责人',
  `check_result` string COMMENT '检查结果',
  `create_time` string COMMENT '记录创建时间'
) COMMENT '违规检查结果表'
PARTITIONED BY (`dt` string, `rid` string COMMENT '规则ID')
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY ',' LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

